const express = require("express");
const conn = require("./mysql.js");
const app = express();
const port = 8080;

//用户账户和密码
//const users = [ { username: 'admin', password: 'password123' } ];
app.get("/login",(req,res)=>{
    //req请求 res.parama.id
    //判断
 //   let user = users.find(u => u.username == req.query.uname && u.password == req.query.upwd);
 //通过连接对象执行连接
 conn.connect((err)=>{
    if(err){
        console.error("1."+err.message);
    }else{
        console.log("1.连接成功!");
    }
 });
 //定义SQL查询
 //let sql = "select * from user where username='admin'and password='123456'";
 let sql = "select * from where username = '"+req.query.uname+"' and password = '" +req.query.upwd + "';";
 //执行SQL
 conn.query(sql,(err,result)=>{
    if(err){
        console.error("2."+err.message);
    }else{
        console.log(result)
        if(result.length > 0){
            res.json({code:200,msg:"登录成功"});
        }else{
            res.json({code:401,msg:"用户名或密码错误"});
        }
    }
 })
});
app.listen(port,()=>{
    console.log("监听端口"+port);
})